object FCoteStageSearch: TFCoteStageSearch
  Left = 0
  Top = 0
  Caption = #22810#20851#36187#32479#35745#25490#21517
  ClientHeight = 537
  ClientWidth = 990
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Splitter1: TSplitter
    Left = 225
    Top = 0
    Height = 537
    ExplicitTop = -53
    ExplicitHeight = 551
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 0
    Width = 225
    Height = 537
    Align = alLeft
    Caption = #36187#20107#21015#34920
    TabOrder = 0
    object Label1: TLabel
      Left = 2
      Top = 496
      Width = 221
      Height = 39
      Align = alBottom
      Caption = #25490#24207#20851#36187#20449#24687#65292#21442#19982#25490#21517#25968#37327#36739#23569#32773#23558#20316#20026#20027#35201#36187#20107#20449#24687#20248#20808#26597#35810#65292#24182#20197#27492#20316#20026#27604#36739#22522#25968#36827#34892#20998#26512#12290
      WordWrap = True
      ExplicitWidth = 216
    end
    object Panel1: TPanel
      Left = 2
      Top = 15
      Width = 221
      Height = 35
      Align = alTop
      BevelOuter = bvNone
      Caption = 'Panel1'
      ShowCaption = False
      TabOrder = 0
      object btnStatisticBySpeed: TBitBtn
        AlignWithMargins = True
        Left = 3
        Top = 3
        Width = 102
        Height = 29
        Align = alLeft
        Caption = #20998#36895#32479#35745
        Default = True
        Glyph.Data = {
          DE010000424DDE01000000000000760000002800000024000000120000000100
          0400000000006801000000000000000000001000000000000000000000000000
          80000080000000808000800000008000800080800000C0C0C000808080000000
          FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
          3333333333333333333333330000333333333333333333333333F33333333333
          00003333344333333333333333388F3333333333000033334224333333333333
          338338F3333333330000333422224333333333333833338F3333333300003342
          222224333333333383333338F3333333000034222A22224333333338F338F333
          8F33333300003222A3A2224333333338F3838F338F33333300003A2A333A2224
          33333338F83338F338F33333000033A33333A222433333338333338F338F3333
          0000333333333A222433333333333338F338F33300003333333333A222433333
          333333338F338F33000033333333333A222433333333333338F338F300003333
          33333333A222433333333333338F338F00003333333333333A22433333333333
          3338F38F000033333333333333A223333333333333338F830000333333333333
          333A333333333333333338330000333333333333333333333333333333333333
          0000}
        NumGlyphs = 2
        TabOrder = 0
        OnClick = btnStatisticBySpeedClick
      end
      object btnStatisticByOrder: TBitBtn
        AlignWithMargins = True
        Left = 111
        Top = 3
        Width = 107
        Height = 29
        Align = alRight
        Caption = #25490#21517#32479#35745
        Glyph.Data = {
          76010000424D7601000000000000760000002800000020000000100000000100
          04000000000000010000120B0000120B00001000000000000000000000000000
          800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
          FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00337000000000
          73333337777777773F333308888888880333337F3F3F3FFF7F33330808089998
          0333337F737377737F333308888888880333337F3F3F3F3F7F33330808080808
          0333337F737373737F333308888888880333337F3F3F3F3F7F33330808080808
          0333337F737373737F333308888888880333337F3F3F3F3F7F33330808080808
          0333337F737373737F333308888888880333337F3FFFFFFF7F33330800000008
          0333337F7777777F7F333308000E0E080333337F7FFFFF7F7F33330800000008
          0333337F777777737F333308888888880333337F333333337F33330888888888
          03333373FFFFFFFF733333700000000073333337777777773333}
        NumGlyphs = 2
        TabOrder = 1
        OnClick = btnStatisticByOrderClick
      end
    end
    object lstMatch: TValueListEditor
      Left = 2
      Top = 50
      Width = 221
      Height = 446
      Align = alClient
      TabOrder = 1
      TitleCaptions.Strings = (
        #36187#20107#21517#31216
        #26377#25928#21517#27425)
      ColWidths = (
        150
        65)
    end
  end
  object Panel2: TPanel
    Left = 228
    Top = 0
    Width = 762
    Height = 537
    Align = alClient
    BevelOuter = bvSpace
    Caption = 'Panel2'
    ShowCaption = False
    TabOrder = 1
    object Panel3: TPanel
      Left = 1
      Top = 501
      Width = 760
      Height = 35
      Align = alBottom
      BevelOuter = bvNone
      Caption = 'Panel3'
      ShowCaption = False
      TabOrder = 0
      object btnExportExcel: TButton
        AlignWithMargins = True
        Left = 640
        Top = 3
        Width = 117
        Height = 29
        Align = alRight
        Caption = #23548#20986'Excel'
        ImageIndex = 34
        ImageMargins.Left = 5
        Images = FCoteDB.ImgButton
        TabOrder = 0
        OnClick = btnExportExcelClick
      end
      object ProgressBar1: TProgressBar
        AlignWithMargins = True
        Left = 3
        Top = 3
        Width = 631
        Height = 29
        Align = alClient
        Step = 1
        TabOrder = 1
      end
    end
    object grid: TStringGrid
      Left = 1
      Top = 1
      Width = 760
      Height = 500
      Align = alClient
      Options = [goFixedVertLine, goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goColSizing, goRowMoving]
      TabOrder = 1
    end
  end
  object DBMatch: TADOTable
    Connection = FCoteDB.ADOConn
    Filter = 'Status<>0'
    Filtered = True
    IndexFieldNames = 'CreateDate'
    TableName = 'JOIN_Match'
    Left = 48
    Top = 160
  end
  object DQStatistic: TADOQuery
    Connection = FCoteDB.ADOConn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'SELECT MG.[PID], MG.[State], MG.[CITY], MG.[County], MG.[MID], M' +
        'G.[MNAME], MG.GBCode, MG.CT, CAST(MG.SumValue AS FLOAT) AS SumVa' +
        'lue FROM(SELECT TT.[PID], TT.[State], TT.[CITY], TT.[County], TT' +
        '.[MID], TT.[MNAME], TT.[GBCode], COUNT(*) AS CT, SUM([Order1])AS' +
        ' SumValue FROM('
      
        'SELECT S.[GameID], P.[ID] AS PID, M.[State], M.[CITY], M.[County' +
        '], P.[MemberIDX] AS MID, M.[MemberName] AS MNAME, P.[GBCode] AS ' +
        'GBCode, S.[Order1]'
      'FROM PGN_GameSource S, PGN_Pigeon P, PGN_Member M'
      
        'WHERE S.[IsBack]=1 AND P.[ID] = S.[PigeonID] AND P.[MemberIDX] =' +
        ' M.[ID]'
      'AND S.[GameID]=1'
      'AND S.[IsBack]=1'
      'AND S.[Order1] <= 123'
      'UNION'
      
        'SELECT S.[GameID], P.[ID] AS PID, M.[State], M.[CITY], M.[County' +
        '], P.[MemberIDX] AS MID, M.[MemberName] AS MNAME, P.[GBCode] AS ' +
        'GBCode, S.[Order1]'
      'FROM PGN_GameSource S, PGN_Pigeon P, PGN_Member M'
      
        'WHERE S.[IsBack]=1 AND P.[ID] = S.[PigeonID] AND P.[MemberIDX] =' +
        ' M.[ID]'
      'AND S.[GameID]=2'
      'AND S.[IsBack]=1'
      'AND S.[Order1] <= 123'
      
        ')AS TT GROUP BY TT.[PID], TT.[State], TT.[CITY], TT.[County], TT' +
        '.[MID], TT.[MNAME], TT.[GBCode])AS MG WHERE MG.CT = 2'
      'ORDER BY MG.SumValue ASC'
      '')
    Left = 48
    Top = 208
  end
  object ImageList1: TImageList
    Left = 440
    Top = 80
    Bitmap = {
      494C010103000400040010001000FFFFFFFFFF10FFFFFFFFFFFFFFFF424D3600
      0000000000003600000028000000400000001000000001002000000000000010
      0000000000000000000000000000000000000000000000000000424242004242
      4200424242004242420042424200424242004242420042424200424242004242
      4200424242004242420042424200000000000000000000000000525252002121
      2100212121002121210042424200424242004242420042424200212121002121
      2100212121005252520000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E70042424200000000000000000052525200DEDEDE005252
      52005252520052525200DEDEDE00DEDEDE00DEDEDE00DEDEDE00525252005252
      520052525200DEDEDE00525252000000000000000000BDBDBD00BDBDBD00BDBD
      BD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBD
      BD00BDBDBD00BDBDBD00BDBDBD00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E70042424200000000000000000052525200DEDEDE00DEDE
      DE00DEDEDE00DEDEDE0052525200525252005252520052525200DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00525252000000000000000000BDBDBD00BDBDBD00BDBD
      BD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBDBD00BDBD
      BD00BDBDBD00BDBDBD00BDBDBD00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E70094949400E7E7E700949494009494940094949400E7E7E700949494009494
      940094949400E7E7E70042424200000000000000000052525200525252000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000005252520052525200000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E700424242000000000052525200DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE005252520000000000FFFFFF00BDBDBD00FFFF
      FF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFF
      FF00BDBDBD00FFFFFF00BDBDBD00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E70094949400E7E7E700949494009494940094949400E7E7E700949494009494
      940094949400E7E7E700424242000000000052525200DEDEDE00DEDEDE00DEDE
      DE00DEDEDE0073737300DEDEDE007373730073737300DEDEDE0073737300DEDE
      DE00DEDEDE00DEDEDE00DEDEDE005252520000000000BDBDBD00FFFFFF00BDBD
      BD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBD
      BD00FFFFFF000000FF00FFFFFF00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E700424242000000000052525200DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE005252520000000000FFFFFF00BDBDBD00FFFF
      FF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFFFF00BDBDBD00FFFF
      FF00BDBDBD00FFFFFF00BDBDBD00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E70094949400E7E7E700949494009494940094949400E7E7E700949494009494
      940094949400E7E7E70042424200000000005252520073737300737373007373
      7300737373007373730073737300737373007373730073737300737373007373
      7300737373007373730073737300525252000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E700424242000000000052525200DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE008484840084848400DEDEDE00DEDEDE00DEDE
      DE00DEDEDE00DEDEDE00DEDEDE00525252000000000000000000000000000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E70094949400E7E7E700949494009494940094949400E7E7E700949494009494
      940094949400E7E7E70042424200000000000000000052525200525252005252
      5200525252005252520052525200DEDEDE00DEDEDE0052525200525252005252
      5200525252005252520052525200000000000000000000000000000000000000
      0000FFFFFF0000000000000000000000000000000000FFFFFF0000000000FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E7004242420000000000000000000000000042424200C6C6
      C60084848400FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF008484
      8400C6C6C6004242420000000000000000000000000000000000000000000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E70042424200000000000000000000000000000000004242
      420084848400FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF008484
      8400424242000000000000000000000000000000000000000000000000000000
      0000FFFFFF000000000000000000FFFFFF000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000424242009494
      9400EFD6C600EFD6C600EFD6C60094949400FFFFFF00F7F7F700FFFFFF00F7F7
      F700FFFFFF00FFFFFF0042424200000000000000000000000000000000000000
      000084848400FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF008484
      8400000000000000000000000000000000000000000000000000000000000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF0000000000FFFFFF00FFFFFF000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000424242009494
      940094949400949494009494940094949400FFFFFF00E7E7E700F7F7F700FFFF
      FF00FFFFFF00FFFFFF0042424200000000000000000000000000000000000000
      000084848400FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF008484
      8400000000000000000000000000000000000000000000000000000000000000
      0000FFFFFF0000000000BDBDBD00FFFFFF0000000000FFFFFF00000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000042424200E7E7
      E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7E700E7E7
      E700E7E7E700E7E7E70042424200000000000000000000000000000000000000
      0000848484008484840084848400848484008484840084848400848484008484
      8400000000000000000000000000000000000000000000000000000000000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000424242004242
      4200424242004242420042424200424242004242420042424200424242004242
      4200424242004242420042424200000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000424D3E000000000000003E000000
      2800000040000000100000000100010000000000800000000000000000000000
      000000000000000000000000FFFFFF00C001C00380010000C001800100000000
      C001800100000000C001800100000000C001000000000000C001000000000000
      C001000000000000C001000000000000C0010000E0070000C0018001E0070000
      C001C003E0070000C001E007E0070000C001F00FE00F0000C001F00FE01F0000
      C001F00FE03F0000C001FFFFE07F000000000000000000000000000000000000
      000000000000}
  end
  object DQItems: TADOQuery
    Connection = FCoteDB.ADOConn
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'PID'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      
        'SELECT P.[ID] AS PID, M.[MatchName] AS GameName, S.[Order1] AS L' +
        'ID, P.[GBCode] AS GBCode, S.[Order1]'
      'FROM PGN_GameSource S, PGN_Pigeon P, PGN_Match M'
      
        'WHERE S.[IsBack]=1 AND P.[ID] = S.[PigeonID] AND S.[GameID]=M.[I' +
        'D] AND P.[ID]=:PID AND('
      'S.[GameID]=1'
      'OR'
      'S.[GameID]=2'
      ')')
    Left = 48
    Top = 264
  end
  object SaveDialog1: TSaveDialog
    Left = 908
    Top = 448
  end
end
